﻿Create PROCEDURE [dbo].[proc_ProjectExpenditure_GetList_FinanceApproveCount]
	(
		@Stext nvarchar(50),
		@CompanyId int
	)
AS
	Select 
		Count(Id)
		From ProjectExpenditure Where (@CompanyId=0 Or CompanyId=@CompanyId) and ManagerApprove=1  and (@Stext is null Or ProjectName like '%'+@Stext+'%')
	
	RETURN